package com.shuyu.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.shuyu.domain.ActivityCollectCardTmp;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ActivityCollectCardTmpMapper extends BaseMapper<ActivityCollectCardTmp> {
    @Select("select t1.*,t2.name as product_name  " +
            "from tbl_activity_collect_card_tmp t1 " +
            "left join tbl_product t2 on t1.product_id = t2.id " +
            "where t1.activity_product_id = #{activityProductId}")
    List<ActivityCollectCardTmp> getCollectCard(Integer activityProductId);
}
